Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# OBJECT_CACHE_OPTIMAL_SIZE

Property | Description
--- | ---
Parameter type | Integer
Default value | `102400` (100K)
Modifiable | `ALTER SESSION`, `ALTER SYSTEM ... DEFERRED`
Range of values | 10 KB to operating system-dependent maximum

The object cache is a memory block on the client that allows applications to store entire objects and to navigate among them without round trips to the server. `OBJECT_CACHE_OPTIMAL_SIZE` specifies (in bytes) the size to which the session object cache is reduced when the size of the cache exceeds the maximum size.

See Also: Oracle Database Concepts, Pro*C/C++ Programmer's Guide, and Oracle Call Interface Programmer's Guide for information on precompiler use of the object cache